Home/
Listings
Condition
On Special Right Now
Used
(7)
Make
Chevrolet
(2)
Ford
(1)
Jeep
(1)
Subaru
(2)
Toyota
(1)
Exterior Color
Black
(2)
Gray
(1)
Red
(2)
Silver
(1)
White
(1)
Category
Pickup Truck
(2)
Sedan
(1)
Sport Utility Vehicle
(3)
Wagon
(1)
8500.00
35995.00
2011 2021
48384
164548
Jeep Wrangler Unlimited 5
Sport Utility Vehicle

Jeep Wrangler Unlimited

2019
Jeep Wrangler Unlimited

Gasoline

Jeep Wrangler Unlimited

48,384mi

Jeep Wrangler Unlimited

Automatic

Jeep Wrangler Unlimited

4 Doors

Top Speed: mi
Engine: 3.6L 6
Color: Silver
Gasoline
48,384mi
Automatic
4 Doors
Sale Price

$35,495.00

$35,995.00

View More
Chevrolet Silverado Crew Cab 6
Pickup Truck

Chevrolet Silverado Crew Cab

2021
Chevrolet Silverado Crew Cab

Gasoline

Chevrolet Silverado Crew Cab

94,903mi

Chevrolet Silverado Crew Cab

Automatic

Chevrolet Silverado Crew Cab

4 Doors

Top Speed: mi
Engine: 5.3L
Color: Black
Gasoline
94,903mi
Automatic
4 Doors
Sale Price

$31,795.00

$32,200.00

View More
Ford F 150 8
Pickup Truck

Ford F 150

2019
Ford F 150

Gasoline

Ford F 150

135,249mi

Ford F 150

Automatic

Ford F 150

4 Doors

Top Speed: mi
Engine: 3.5 Eco Boost
Color: White
Gasoline
135,249mi
Automatic
4 Doors
Sale Price

$27,490.00

$27,998.00

View More
Toyota Rav4 5
Sport Utility Vehicle

Toyota Rav4

2020
Toyota Rav4

Gasoline

Toyota Rav4

97,402mi

Toyota Rav4

Automatic

Toyota Rav4

4 Doors

Top Speed: mi
Engine: 2.5L 4
Color: Black
Gasoline
97,402mi
Automatic
4 Doors
Sale Price

$23,995.00

$25,500.00

View More
Chevrolet Traverse 3
Sport Utility Vehicle

Chevrolet Traverse

2016
Chevrolet Traverse

Gasoline

Chevrolet Traverse

83,285mi

Chevrolet Traverse

Automatic

Chevrolet Traverse

4 Doors

Top Speed: mi
Engine: 3.6L 6
Color: Gray
Gasoline
83,285mi
Automatic
4 Doors
Sale Price

$16,998.00

$16,998.00

View More
Subaru Outback 12
Wagon

Subaru Outback

2011
Subaru Outback

Gasoline

Subaru Outback

156,737mi

Subaru Outback

Automatic

Subaru Outback

4 Doors

Top Speed: mi
Engine: 2.5L 4
Color: Red
Gasoline
156,737mi
Automatic
4 Doors
Sale Price

$8,995.00

$9,600.00

View More
Subaru Legacy 6
Sedan

Subaru Legacy

2012
Subaru Legacy

Gasoline

Subaru Legacy

164,548mi

Subaru Legacy

Automatic

Subaru Legacy

4 Doors

Top Speed: mi
Engine: 2.5L 4
Color: Red
Gasoline
164,548mi
Automatic
4 Doors
Sale Price

$8,500.00

$8,500.00

View More
Total: 7 / Current Page: 1 of 1

Total execution time: 1716149246.6473 sec.

Framework 1.50 v3.00

Cpu Usage 26290 sec.

Memory Usage 785.4kB

POST: 
Array
(
)
GET: 
Array
(
    [order] => price|DESC
)

                         
Array
(
    [segment] => Array
        (
            [0] => listings
        )

    [route] => /listings
    [template] => front/themes/master/listings.tpl.php
)

1. select | total: 1
SELECT * FROM `settings` WHERE (`id` = 1) ;

2. count | total: 7
SELECT COUNT(*) AS items FROM `listings` WHERE (`status` = 1) ;

3. SELECT | total: 7
SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.gallery, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 ORDER BY price DESC LIMIT 0,24;

4. SELECT | total: 2
SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;

1. select | total: 1. SELECT * FROM `settings` WHERE (`id` = 1) ;
2. count | total: 7. SELECT COUNT(*) AS items FROM `listings` WHERE (`status` = 1) ;
3. SELECT | total: 7.  SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.gallery, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 ORDER BY price DESC LIMIT 0,24;
4. SELECT | total: 2.  SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;
2. count | total: 1. SELECT COUNT(*) AS items FROM `listings` AS l LEFT JOIN `listings_info` li ON l.id = li.listing_id WHERE li.lstatus = 1 AND li.color_name = 'silver';
3. SELECT | total: 1.  SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.gallery, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 AND li.color_name = 'silver' ORDER BY created DESC LIMIT 0,24;